Creating a new query using the Crystal SQL Designer

Accessing the Crystal SQL Designer

  1. On the Start menu, select Programs, select Crystal Reports Tools, then click Crystal SQL Designer.

    Note:    The location of the Crystal SQL Designer may vary depending on the location you specified during installation.

  2. On the File menu, click New.

    The New Query dialog box appears.

  3. Click Use SQL Expert.

The Create SQL Expert appears. This expert contains six tabs that will lead you step-by-step through the query creation process.

Note:    The Links tab only appears when two or more database tables are selected on the Tables tab.

Previewing data

Once you select at least one field for the query on the Fields tab, you can view the data retrieved by your query at any time, by clicking Finish at the bottom of the dialog box. After you are done viewing the query data, click Edit and choose Query to return to the Create SQL Expert.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com